Shaine Greenwood
Shaine Greenwood
Reactions
-
Re: IF, AND, OR Functions
Hi dana, If you're getting an #UNPARSEABLE error on your second formula, it's likely due to the mixture of straight quotes vs curly quotes. Smartsheet can only understand straight quotes in formulas.…2 · -
Re: Item Tracking
Hi Luke, You might try adding a checkbox column to your sheet with a function that checks the box if it's the most recently submitted item, for instance: =IF(MAX([Auto-Created Column Name]:[Auto-Crea…1 · -
Re: Pasting into an Auto-number does not auto-number in sequence
@christian — please email support@smartsheet.com and troubleshoot with them further. This seems like it might be a bug and the support team will want to troubleshoot this with you.1 · -
Re: Moving Rows to other sheets for non-Admin users
Hi Hailey, When moving rows to another sheet, if the destination sheet needs to create new columns for the row move to be successful, she won't be able to move those rows unless she's an Admin on the…1 · -
Re: How to display the grandparent task name or value in a cell
Hello, You can use an index of 1 to identify the parent-most cell: =INDEX(ANCESTORS(), 1) If you're wanting to identify the grandparent of one cell from another, reference that adjacent child cell: =…2 ·
